Show All

Add a trendline to a chart

1. Click the data series to which you want to add a trendline or moving average.
2. On the Chart menu, click Add Trendline.
3. On the Type tab, click the type of regression trendline or moving average you want.

   • If you select Polynomial, enter in the Order box the highest power for the independent variable.

   • If you select Moving Average, enter in the Period box the number of periods to be used to calculate the moving average.

Notes

• The Based on series box lists all the data series in the chart that support trendlines. To add a trendline to another series, click the name in the box, and then select the options you want.
• If you add a moving average to an xy (scatter) chart, the moving average is based on the order of the x values plotted in the chart. To get the result you want, you might need to sort the x values before adding a moving average.